[question]master-slave sync delay

--0015174c1c1e1ddb7e04ace346a7
Content-Type: text/plain; charset=ISO-8859-1

Hi, all:

There is a problem about master-slave sync delay,
I find some infomations from 'show processlist', some like that:

1051 system user ns Connect 10 update xxx

what does Connect mean, mysql manual explained:

Connect

A replication slave is connected to its master.
Then, There is 10s delay from master to slave.
I want to know why does this happend, slow network I/O? or something wrong
with this update SQL?

Thanks
Regards

W.J

--0015174c1c1e1ddb7e04ace346a7--
jiangwen jiang [ Mi, 14 September 2011 11:20 ] [ ID #2064324 ]
Datenbanken » gmane.comp.db.mysql.general » [question]master-slave sync delay

Vorheriges Thema: Moving database from one machine to another machine..
Nächstes Thema: Triggers - Accessing all NEW data